Tabela phstitemhist

Definicja tabeli phstitemhist

Name

phstitemhist

Code

phstitemhist

Comment

Asortyment magazynów


Lista kolumn tabeli phstitemhist

Name

Code

StItemID

StItemID

ResourceID

ResourceID

PackID

PackID

StItemKindID

StItemKindID

Description

Description

Avaliable

Avaliable

Name

Name

StartDT

StartDT

StopDT

StopDT

Active

Active

DirectorateApprovalForOrder

DirectorateApprovalForOrder

PatientRequiredForOrder

PatientRequiredForOrder

Imported

Imported

OldSystemID

OldSystemID

HeadOfTheWardApprovalForOrder

HeadOfTheWardApprovalForOrder

ExternalLink

ExternalLink

rev

rev

RevTypeId

RevTypeId


Kolumna StItemID tabeli phstitemhist

Definicja kolumny StItemID tabeli phstitemhist

Name

StItemID

Code

StItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu magazynu


Kolumna ResourceID tabeli phstitemhist

Definicja kolumny ResourceID tabeli phstitemhist

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PackID tabeli phstitemhist

Definicja kolumny PackID tabeli phstitemhist

Name

PackID

Code

PackID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StItemKindID tabeli phstitemhist

Definicja kolumny StItemKindID tabeli phstitemhist

Name

StItemKindID

Code

StItemKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Description tabeli phstitemhist

Definicja kolumny Description tabeli phstitemhist

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis


Kolumna Avaliable tabeli phstitemhist

Definicja kolumny Avaliable tabeli phstitemhist

Name

Avaliable

Code

Avaliable

Data Type

NUMBER(3)

Mandatory

No

Comment

Asortyment dostepny


Kolumna Name tabeli phstitemhist

Definicja kolumny Name tabeli phstitemhist

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa


Kolumna StartDT tabeli phstitemhist

Definicja kolumny StartDT tabeli phstitemhist

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku obowiazywania/okresu


Kolumna StopDT tabeli phstitemhist

Definicja kolumny StopDT tabeli phstitemhist

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca obowiazywania/okresu


Kolumna Active tabeli phstitemhist

Definicja kolumny Active tabeli phstitemhist

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Flaga aktywnosci w systemie


Kolumna DirectorateApprovalForOrder tabeli phstitemhist

Definicja kolumny DirectorateApprovalForOrder tabeli phstitemhist

Name

DirectorateApprovalForOrder

Code

DirectorateApprovalForOrder

Data Type

NUMBER(3)

Mandatory

No

Comment

Lek wymaga zatwierdzenia dyrekcji przy zamówieniu


Kolumna PatientRequiredForOrder tabeli phstitemhist

Definicja kolumny PatientRequiredForOrder tabeli phstitemhist

Name

PatientRequiredForOrder

Code

PatientRequiredForOrder

Data Type

NUMBER(3)

Mandatory

No

Comment

Lek wymaga pacjenta przy zamówieniu


Kolumna Imported tabeli phstitemhist

Definicja kolumny Imported tabeli phstitemhist

Name

Imported

Code

Imported

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Lek pochodzi z importu docelowego


Kolumna OldSystemID tabeli phstitemhist

Definicja kolumny OldSystemID tabeli phstitemhist

Name

OldSystemID

Code

OldSystemID

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Identyfikatory ze starego systemu


Kolumna HeadOfTheWardApprovalForOrder tabeli phstitemhist

Definicja kolumny HeadOfTheWardApprovalForOrder tabeli phstitemhist

Name

HeadOfTheWardApprovalForOrder

Code

HeadOfTheWardApprovalForOrder

Data Type

NUMBER(3)

Mandatory

No

Comment

Lek wymaga zgody ordynatora przy zamawianiu


Kolumna ExternalLink tabeli phstitemhist

Definicja kolumny ExternalLink tabeli phstitemhist

Name

ExternalLink

Code

ExternalLink

Data Type

VARCHAR2(255)

Mandatory

No

Comment

do zapisu linku do zewnetrznej charakterystyki leku


Kolumna rev tabeli phstitemhist

Definicja kolumny rev tabeli phstitemhist

Name

rev

Code

rev

Data Type

NUMBER(10)

Mandatory

No

Comment

FK do tabeli
REVINFO


Kolumna RevTypeId tabeli phstitemhist

Definicja kolumny RevTypeId tabeli phstitemhist

Name

RevTypeId

Code

RevTypeId

Data Type

NUMBER(3)

Mandatory

No

Comment